﻿<%@ Page Title="用户资料管理" Language="C#" MasterPageFile="~/Common2.Master" AutoEventWireup="true" CodeBehind="WebAdmin2.aspx.cs" Inherits="loginWeb.WebAdmin2" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    <style type="text/css">
        .auto-style3 {
            font-size: x-large;
            color: #434C5C;
        }
        .auto-style4 {
            font-size: x-large;
            color: #003366;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <div style="font-family: 方正报宋_GBK; font-size: medium; position: absolute; z-index: auto; width: 200px; height: 200px; top: 400px; left: 50px">
        <asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="#3366CC" BorderWidth="1px" CellPadding="1" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="#003399" Height="200px" style="margin-left: 0px" Width="220px">
            <DayHeaderStyle BackColor="#99CCCC" ForeColor="#336666" Height="1px" />
            <NextPrevStyle Font-Size="8pt" ForeColor="#CCCCFF" />
            <OtherMonthDayStyle ForeColor="#999999" />
            <SelectedDayStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <SelectorStyle BackColor="#99CCCC" ForeColor="#336666" />
            <TitleStyle BackColor="#003399" BorderColor="#3366CC" BorderWidth="1px" Font-Bold="True" Font-Size="10pt" ForeColor="#CCCCFF" Height="25px" />
            <TodayDayStyle BackColor="#99CCCC" ForeColor="White" />
            <WeekendDayStyle BackColor="#CCCCFF" />
        </asp:Calendar>
    </div>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <span class="auto-style4">输入用户</span><span class="auto-style3">名：</span><span class="auto-style1"><asp:TextBox ID="TextBox1" runat="server" Height="22px" style="text-align: center" Width="204px"></asp:TextBox>
&nbsp;
    <asp:Button ID="btnSearch" runat="server" BackColor="#434C5C" ForeColor="White" Height="31px" Text="查询" Width="64px" />
&nbsp;
    <asp:Button ID="Button1" runat="server" BackColor="#33CCFF" ForeColor="White" Height="32px" PostBackUrl="~/WebAdmin1.aspx" style="margin-top: 0px" Text="返回" Width="55px" />
    <br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="登录名,邮箱" DataSourceID="SqlDataSource1" Font-Size="Large" ForeColor="#333333" GridLines="None" style="margin-left: 320px; margin-top: 44px" Width="708px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            <asp:BoundField DataField="登录名" HeaderText="登录名" ReadOnly="True" SortExpression="登录名" />
            <asp:BoundField DataField="邮箱" HeaderText="邮箱" ReadOnly="True" SortExpression="邮箱" />
            <asp:BoundField DataField="日记" HeaderText="日记" SortExpression="日记" />
            <asp:BoundField DataField="收藏" HeaderText="收藏" SortExpression="收藏" />
            <asp:BoundField DataField="一句话" HeaderText="一句话" SortExpression="一句话" />
            <asp:BoundField DataField="wechat" HeaderText="wechat" SortExpression="wechat" />
            <asp:BoundField DataField="年龄" HeaderText="年龄" SortExpression="年龄" />
            <asp:BoundField DataField="所在地" HeaderText="所在地" SortExpression="所在地" />
        </Columns>
        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#E9E7E2" />
        <SortedAscendingHeaderStyle BackColor="#506C8C" />
        <SortedDescendingCellStyle BackColor="#FFFDF8" />
        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:dhd2014112109ConnectionString %>" DeleteCommand="DELETE FROM [Users1] WHERE [登录名] = @original_登录名 AND [邮箱] = @original_邮箱 AND (([日记] = @original_日记) OR ([日记] IS NULL AND @original_日记 IS NULL)) AND (([收藏] = @original_收藏) OR ([收藏] IS NULL AND @original_收藏 IS NULL)) AND (([一句话] = @original_一句话) OR ([一句话] IS NULL AND @original_一句话 IS NULL)) AND (([wechat] = @original_wechat) OR ([wechat] IS NULL AND @original_wechat IS NULL)) AND (([年龄] = @original_年龄) OR ([年龄] IS NULL AND @original_年龄 IS NULL)) AND (([所在地] = @original_所在地) OR ([所在地] IS NULL AND @original_所在地 IS NULL))" InsertCommand="INSERT INTO [Users1] ([登录名], [邮箱], [日记], [收藏], [一句话], [wechat], [年龄], [所在地]) VALUES (@登录名, @邮箱, @日记, @收藏, @一句话, @wechat, @年龄, @所在地)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [登录名], [邮箱], [日记], [收藏], [一句话], [wechat], [年龄], [所在地] FROM [Users1] WHERE ([登录名] = @登录名) ORDER BY [登录名]" UpdateCommand="UPDATE [Users1] SET [日记] = @日记, [收藏] = @收藏, [一句话] = @一句话, [wechat] = @wechat, [年龄] = @年龄, [所在地] = @所在地 WHERE [登录名] = @original_登录名 AND [邮箱] = @original_邮箱 AND (([日记] = @original_日记) OR ([日记] IS NULL AND @original_日记 IS NULL)) AND (([收藏] = @original_收藏) OR ([收藏] IS NULL AND @original_收藏 IS NULL)) AND (([一句话] = @original_一句话) OR ([一句话] IS NULL AND @original_一句话 IS NULL)) AND (([wechat] = @original_wechat) OR ([wechat] IS NULL AND @original_wechat IS NULL)) AND (([年龄] = @original_年龄) OR ([年龄] IS NULL AND @original_年龄 IS NULL)) AND (([所在地] = @original_所在地) OR ([所在地] IS NULL AND @original_所在地 IS NULL))">
        <DeleteParameters>
            <asp:Parameter Name="original_登录名" Type="String" />
            <asp:Parameter Name="original_邮箱" Type="String" />
            <asp:Parameter Name="original_日记" Type="String" />
            <asp:Parameter Name="original_收藏" Type="String" />
            <asp:Parameter Name="original_一句话" Type="String" />
            <asp:Parameter Name="original_wechat" Type="String" />
            <asp:Parameter Name="original_年龄" Type="Int32" />
            <asp:Parameter Name="original_所在地" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="登录名" Type="String" />
            <asp:Parameter Name="邮箱" Type="String" />
            <asp:Parameter Name="日记" Type="String" />
            <asp:Parameter Name="收藏" Type="String" />
            <asp:Parameter Name="一句话" Type="String" />
            <asp:Parameter Name="wechat" Type="String" />
            <asp:Parameter Name="年龄" Type="Int32" />
            <asp:Parameter Name="所在地" Type="String" />
        </InsertParameters>
        <SelectParameters>
            <asp:ControlParameter ControlID="TextBox1" Name="登录名" PropertyName="Text" Type="String" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="日记" Type="String" />
            <asp:Parameter Name="收藏" Type="String" />
            <asp:Parameter Name="一句话" Type="String" />
            <asp:Parameter Name="wechat" Type="String" />
            <asp:Parameter Name="年龄" Type="Int32" />
            <asp:Parameter Name="所在地" Type="String" />
            <asp:Parameter Name="original_登录名" Type="String" />
            <asp:Parameter Name="original_邮箱" Type="String" />
            <asp:Parameter Name="original_日记" Type="String" />
            <asp:Parameter Name="original_收藏" Type="String" />
            <asp:Parameter Name="original_一句话" Type="String" />
            <asp:Parameter Name="original_wechat" Type="String" />
            <asp:Parameter Name="original_年龄" Type="Int32" />
            <asp:Parameter Name="original_所在地" Type="String" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <br />
    </span></asp:Content>
